<!DOCTYPE HTML>
<html lang="zh">
<head>
<title>Apache Hive 中文手册 - Apache Hive 3.1.1 Language Manual | Docs4dev</title>
<meta charset="UTF-8">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta name="description" content="Apache Hive™ 有助于使用SQL读取，编写和管理驻留在分布式存储中的大型数据集。它可以将结构投影到已存储的数据中。同时提供了命令行工具和 JDBC 驱动程序以将用户连接到 Hive。">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="HandheldFriendly" content="true">
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="black">
<meta property="og:type" content="website">
<meta property="og:title" content="Apache Hive 中文手册 - Apache Hive 3.1.1 Language Manual">
<meta property="og:url" content="https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/">
<meta property="og:site_name" content="Docs4dev">
<meta property="og:locale" content="zh_CN">
<meta name="twitter:card" content="Apache Hive™ 有助于使用SQL读取，编写和管理驻留在分布式存储中的大型数据集。它可以将结构投影到已存储的数据中。同时提供了命令行工具和 JDBC 驱动程序以将用户连接到 Hive。">
<meta name="generator" content="Docs4dev template engine">
<link rel="stylesheet" href="static/css/app.min.css">
<link rel="shortcut icon" href="https://www.docs4dev.com/static/images/favicon.ico" type="image/x-icon">
<script async="" src="static/js/js.js"></script>
<script async="" src="static/js/adsbygoogle.js" crossorigin="anonymous"></script>
<script>
    window.dataLayer = window.dataLayer || [];

    function gtag() {
      dataLayer.push(arguments);
    }

    gtag('js', new Date());
    gtag('config', 'UA-129571937-1');
  </script>
<link rel="amphtml" href="https://www.docs4dev.com/amp/docs/zh/apache-hive/3.1.1/reference/index.html">

<script type="application/ld+json">{"name":null,"headline":"Apache Hive 中文手册-Apache Hive 3.1.1 Language Manual","inLanguage":"zh-CN","version":"3.1.1","image":"/static/icon/icon-hive.png","datePublished":"2021-05-20T12:51:01Z","dateCreated":"2021-05-20T12:51:01Z","dateModified":"2021-07-05T14:25:28Z","@context":"https://schema.org/","@type":"APIReference","abstract":"Apache Hive™ 有助于使用SQL读取，编写和管理驻留在分布式存储中的大型数据集。它可以将结构投影到已存储的数据中。同时提供了命令行工具和 JDBC 驱动程序以将用户连接到 Hive。"}</script>
</head>
<body>
<div class="book with-summary">
<div class="book-summary">
<div class="logo">
<a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference');" style="color: inherit;">
<img src="static/picture/icon-hive.png" style="width: 48px; height: 48px;" alt="Logo">
</a>
<b style="color: inherit; margin-left: 8px;">Apache Hive 中文手册</b>
</div>
<div class="item">
<div>
<label for="version">版本</label>
<select id="version" onchange="onVersionChange(this)">
<option value="3.1.1" selected="selected">3.1.1</option>
</select>
</div>
<div style="margin-top: 8px;">
<label for="language">语言</label>
<select id="language" onchange="onLangChange(this)" value="zh">
<option value="en">English</option>
<option value="zh" selected="selected">中文</option>
</select>
</div>

</div>
<div class="item menus">
<a title="Table of Contents" style="margin-right: 8px;" href="#">
<i class="fa fa-chevron-left"></i>
<span style="margin-left: 2px;">返回目录</span>
</a>
</div>
<nav role="navigation" id="navigation">
<ul class="summary">
<li class="chapter"> <a href="" title="命令和 CLI"> 命令和 CLI </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Commands.html');" title="Commands"> Commands </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Cli.html');" title="Hive CLI"> Hive CLI </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/HiveServer2_Clients.html');" title="Beeline CLI"> Beeline CLI </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_VariableSubstitution.html');" title="Variable Substitution"> Variable Substitution </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/HCatalog_CLI.html');" title="HCatalog CLI"> HCatalog CLI </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="File Formats"> File Formats </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/AvroSerDe.html');" title="Avro Files"> Avro Files </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_ORC.html');" title="ORC Files"> ORC Files </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Parquet.html');" title="Parquet"> Parquet </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/CompressedStorage.html');" title="压缩数据存储"> 压缩数据存储 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_LZO.html');" title="LZO Compression"> LZO Compression </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Types.html');" title="Data Types"> Data Types </a> </li>
<li class="chapter"> <a href="" title="数据定义语句"> 数据定义语句 </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DDL.html');" title="DDL Statements"> DDL Statements </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DDL_BucketedTables.html');" title="Bucketed Tables"> Bucketed Tables </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/StatsDev.html');" title="统计(分析和描述)"> 统计(分析和描述) </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Indexing.html');" title="Indexes"> Indexes </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Archiving.html');" title="Archiving"> Archiving </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="数据处理语句"> 数据处理语句 </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DML.html');" title="DML：加载，插入，更新，删除"> DML：加载，插入，更新，删除 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_ImportExport.html');" title="Import/Export"> Import/Export </a> </li>
</ul> </li>
<li class="chapter"> <a href="" title="数据检索：查询"> 数据检索：查询 </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Select.html');" title="Select"> Select </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_GroupBy.html');" title="Group By"> Group By </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_SortBy.html');" title="Sort/Distribute/Cluster/Order By"> Sort/Distribute/Cluster/Order By </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Transform.html');" title="转换和 Map-Reduce 脚本"> 转换和 Map-Reduce 脚本 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_UDF.html');" title="运算符和用户定义的函数(UDF)"> 运算符和用户定义的函数(UDF) </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_XPathUDF.html');" title="XPath-specific Functions"> XPath-specific Functions </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Joins.html');" title="Joins"> Joins </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_JoinOptimization.html');" title="Join Optimization"> Join Optimization </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Union.html');" title="Union"> Union </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_LateralView.html');" title="Lateral View"> Lateral View </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_SubQueries.html');" title="Sub Queries"> Sub Queries </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Sampling.html');" title="Sampling"> Sampling </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_VirtualColumns.html');" title="Virtual Columns"> Virtual Columns </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_WindowingAndAnalytics.html');" title="窗口和分析功能"> 窗口和分析功能 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Enhanced_Aggregation__Cube__Grouping_and_Rollup.html');" title="增强的聚合，多维数据集，分组和汇总"> 增强的聚合，多维数据集，分组和汇总 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive HPL/SQL"> Hive HPL/SQL </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Explain.html');" title="解释执行计划"> 解释执行计划 </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Locks.html');" title="Locks"> Locks </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Authorization.html');" title="Authorization"> Authorization </a>
<ul class="articles">
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Storage_Based_Authorization_in_the_Metastore_Server.html');" title="基于存储的授权"> 基于存储的授权 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/SQL_Standard_Based_Hive_Authorization.html');" title="基于 SQL 标准的授权"> 基于 SQL 标准的授权 </a> </li>
<li class="chapter"> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive 不推荐使用的授权模式/旧版模式"> Hive 不推荐使用的授权模式/旧版模式 </a> </li>
</ul> </li>
<li class="chapter"> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Configuration_Properties.html');" title="Configuration Properties"> Configuration Properties </a> </li>
</ul>
</nav>
</div>
<div class="book-body">
<div class="body-inner">
<header class="book-header">
<div class="dropdown pull-right js-toolbar-action">
<a class="btn toggle-dropdown" aria-label="Language" href="#">
<i class="fa fa-globe"></i>
</a>
<div class="dropdown-menu dropdown-left">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<button class="button size-1" onclick="changeLang('zh_CN')">中文</button>
</div>
<div class="buttons">
<button class="button size-1" onclick="changeLang('en_US')">English</button>
</div>
</div>
</div>
<a class="btn pull-right js-toolbar-action non-mobile" aria-label="Sign up" href="register.html">
<i class="fa fa-sign-in"></i> <span>注册</span>
</a>
<a class="btn pull-right js-toolbar-action non-mobile" aria-label="Sign in" href="register.html">
<i class="fa fa-sign-in"></i>
<span>登录</span>
</a>
<a class="btn pull-left js-toolbar-action btn-summary" href="#"><i class="fa fa-align-justify"></i></a>
<div class="dropdown pull-left font-settings js-toolbar-action">
<a class="btn toggle-dropdown" aria-label="Font Settings" href="#">
<i class="fa fa-font"></i>
</a>
<div class="dropdown-menu dropdown-right">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<button class="button size-2 font-reduce">A</button>
<button class="button size-2 font-enlarge">A</button>
</div>
<div class="buttons">
<button class="button size-2 family-serif">Serif</button>
<button class="button size-2 family-sans">Sans</button>
</div>
<div class="buttons">
<button class="button size-3 theme-white">White</button>
<button class="button size-3 theme-sepia">Sepia</button>
<button class="button size-3 theme-night">Night</button>
</div>
</div>
</div>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Home" href="zh.html">
<i class="fa fa-home"></i> <span>首页</span>
</a>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Guide" href="javascript:window.open('https://www.javadoc.org/');">
<i class="fa fa-book"></i> <span>API Docs</span>
</a>
<a class="btn pull-left js-toolbar-action non-mobile" aria-label="Tools" href="index1.html">
<i class="fa fa-gears"></i> <span>工具</span>
</a>
<div class="dropdown pull-left js-toolbar-action mobile">
<a class="btn toggle-dropdown" aria-label="Language" href="#">
<i class="fa fa-chevron-down"></i>
</a>
<div class="dropdown-menu dropdown-right">
<div class="dropdown-caret"><span class="caret-outer"></span><span class="caret-inner"></span></div>
<div class="buttons">
<a class="button size-1" aria-label="Home" href="zh.html">
<i class="fa fa-home"></i> <span>首页</span>
</a>
</div>
<div class="buttons">
<a class="button size-1" aria-label="Guide" href="javascript:window.open('https://www.javadoc.org/');">
<i class="fa fa-book"></i> <span>API Docs</span>
</a>
</div>
<div class="buttons">
<a class="button size-1" aria-label="Tools" href="index1.html">
<i class="fa fa-gears"></i> <span>工具</span>
</a>
</div>
</div>
</div>
<div id="autocomplete" class="pull-right"></div>
<span id="toolbar-title"></span>
</header>
<div class="page-wrapper" tabindex="-1" role="main">
<div class="page-inner">
<section class="normal markdown-section">
<div id="content">
<h1>Apache Hive 3.1.1 Language Manual</h1>
<div><ins class="adsbygoogle" style="display:block; text-align:center;" data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-6108808167664152" data-ad-slot="6964403648"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
<div><div class="divider">
<span class="divider-inner-text">Table of Contents</span>
</div>
<ul class="toc">
<li> <a href="" title="命令和 CLI"> 命令和 CLI </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Commands.html');" title="Commands"> Commands </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Cli.html');" title="Hive CLI"> Hive CLI </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/HiveServer2_Clients.html');" title="Beeline CLI"> Beeline CLI </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_VariableSubstitution.html');" title="Variable Substitution"> Variable Substitution </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/HCatalog_CLI.html');" title="HCatalog CLI"> HCatalog CLI </a> </li>
</ul> </li>
<li> <a href="" title="File Formats"> File Formats </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/AvroSerDe.html');" title="Avro Files"> Avro Files </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_ORC.html');" title="ORC Files"> ORC Files </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Parquet.html');" title="Parquet"> Parquet </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/CompressedStorage.html');" title="压缩数据存储"> 压缩数据存储 </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_LZO.html');" title="LZO Compression"> LZO Compression </a> </li>
</ul> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Types.html');" title="Data Types"> Data Types </a> </li>
<li> <a href="" title="数据定义语句"> 数据定义语句 </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DDL.html');" title="DDL Statements"> DDL Statements </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DDL_BucketedTables.html');" title="Bucketed Tables"> Bucketed Tables </a> </li>
</ul> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/StatsDev.html');" title="统计(分析和描述)"> 统计(分析和描述) </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Indexing.html');" title="Indexes"> Indexes </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Archiving.html');" title="Archiving"> Archiving </a> </li>
</ul> </li>
<li> <a href="" title="数据处理语句"> 数据处理语句 </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_DML.html');" title="DML：加载，插入，更新，删除"> DML：加载，插入，更新，删除 </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_ImportExport.html');" title="Import/Export"> Import/Export </a> </li>
</ul> </li>
<li> <a href="" title="数据检索：查询"> 数据检索：查询 </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Select.html');" title="Select"> Select </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_GroupBy.html');" title="Group By"> Group By </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_SortBy.html');" title="Sort/Distribute/Cluster/Order By"> Sort/Distribute/Cluster/Order By </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Transform.html');" title="转换和 Map-Reduce 脚本"> 转换和 Map-Reduce 脚本 </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_UDF.html');" title="运算符和用户定义的函数(UDF)"> 运算符和用户定义的函数(UDF) </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_XPathUDF.html');" title="XPath-specific Functions"> XPath-specific Functions </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Joins.html');" title="Joins"> Joins </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_JoinOptimization.html');" title="Join Optimization"> Join Optimization </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Union.html');" title="Union"> Union </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_LateralView.html');" title="Lateral View"> Lateral View </a> </li>
</ul> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_SubQueries.html');" title="Sub Queries"> Sub Queries </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Sampling.html');" title="Sampling"> Sampling </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_VirtualColumns.html');" title="Virtual Columns"> Virtual Columns </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_WindowingAndAnalytics.html');" title="窗口和分析功能"> 窗口和分析功能 </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Enhanced_Aggregation__Cube__Grouping_and_Rollup.html');" title="增强的聚合，多维数据集，分组和汇总"> 增强的聚合，多维数据集，分组和汇总 </a> </li>
<li> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive HPL/SQL"> Hive HPL/SQL </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Explain.html');" title="解释执行计划"> 解释执行计划 </a> </li>
</ul> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Locks.html');" title="Locks"> Locks </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/LanguageManual_Authorization.html');" title="Authorization"> Authorization </a>
<ul class="articles">
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Storage_Based_Authorization_in_the_Metastore_Server.html');" title="基于存储的授权"> 基于存储的授权 </a> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/SQL_Standard_Based_Hive_Authorization.html');" title="基于 SQL 标准的授权"> 基于 SQL 标准的授权 </a> </li>
<li> <a href="javascript:window.open('https://cwiki.apache.org/confluence/pages/viewpage.action');" title="Hive 不推荐使用的授权模式/旧版模式"> Hive 不推荐使用的授权模式/旧版模式 </a> </li>
</ul> </li>
<li> <a href="javascript:window.open('https://www.docs4dev.com/docs/zh/apache-hive/3.1.1/reference/Configuration_Properties.html');" title="Configuration Properties"> Configuration Properties </a> </li>
</ul></div>
</div>
</section>
<div class="right-sidebar">
<div class="affix"><ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6108808167664152" data-ad-slot="3102929424" data-ad-format="auto" data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script></div>
</div>
</div>
<div class="ft">
<a href="#toolbar-title" id="anchorNavigationExGoTop"><i class="fa fa-arrow-up"></i></a>
<footer class="footer">
<div class="footer__container--normal">
<img alt="扫码关注公众号" title="扫码关注公众号" src="static/picture/qr-code.png" width="170" height="170">
<div class="footer__description--normal">
<p class="paragraph footer__author--normal">Docs4dev<sup class="super">&#xAE;</sup>
</p>
<p class="paragraph footer__quote&#45;&#45;normal">
如果你在使用过程中遇到任何问题，可以在 <a href="javascript:window.open('https://github.com/docs4dev/docs4dev-issues');" target="_blank" rel="noopener noreferrer">这里<i class="fa fa-external-link"></i></a> 提issue。
</p>
<div class="footer__main--normal">
<p class="paragraph footer__main__paragraph--normal copyright" style="color: #666 !important;">
<a href="javascript:window.open('https://beian.miit.gov.cn/');">
蜀ICP备14021783号-6
</a>
</p>
<p class="paragraph footer__main__paragraph--normal copyright" style="color: #666 !important;">
Copyright &#xA9; Docs4dev all
right reserved, powered by <a href="index2.html" target="_blank">Docs4dev</a></p>
</div>
</div>
</div>
<div class="box__issues">
</div>
</footer>
</div>
</div>
</div>
</div>
</div>
<script>
  var hasToc = true;
  /*  var downloadable = /!*false*!/ false;
    var editable = /!*false*!/ false;
    var code = /!*"apache-hive"*!/ false;
    var version = /!*"3.1.1"*!/ false;
    var type = /!*"reference"*!/ false;
    var lang = /!*"zh"*!/ 'en';
    //edit link
    require(["gitbook", "jQuery"], function (gitbook, $) {
      gitbook.events.bind('start', function (e, config) {
        // Add edit toolbar to left
        var chapterId = /!*16886*!/ 0;
        if (downloadable) {
          gitbook.toolbar.createButton({
            icon: 'fa fa-download',
            text: '下载',
            onClick: function () {
              window.open('/download?code=' + code + '&version=' + version + '&type=' + type + '&lang=' + lang);
            }
          });
        }
        if (editable) {
          gitbook.toolbar.createButton({
            icon: 'fa fa-edit',
            text: '编辑此页',
            onClick: function () {
              window.open('/docs/edit?chapterId=' + chapterId + '&lang=' + lang);
            }
          });
        }
      });
    });*/
</script>
<script>
    var code = "apache-hive";
    var lang = "zh";
  </script>

<script src="static/js/autocomplete-js.js"></script>
<script src="static/js/app.min.js"></script>
<script src="static/js/search.min.js"></script>
</body>
</html>
